Arial
Times New Roman
Wingdings
Monotype Sorts
Symbol
Letter
Display
0 = IDEF1X; 2 = Relational
`SOverrides the relationship notation specifed by the IDEF1X or Relational notations.
`)Set to hide all relationships on the page
Set to hide relationship text.
`*Set to hide PK, FK, and Index annotations.
`'Set to hide the PK section of Entities.
`.Set to hide the Datatype section for Entities.
`\Set to hide the vertical lines seperating the Annotation and Datatype sections for Entities.
`jSet to hide the horizontal line seperating the Primary Key section from the other columns within Entities.
Relationships
Use the Relationship connector to define a foreign key between two tables.
Vis_D200.chm!#20000 `?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
IDEF1X Notation
Crow's Foot Notation
Relational Notation
Relationship (Foreign Key)
`%Unique identifier used by the add-on.
`BSet to indicate the relationship is an 'Identifying Relationship'.
`C25=exactly one, 28=one or more, 29=zero one or more, 30=zero or one
`-Set to indicate the relationship is optional.
`RSet to override Database | Document | Options locally for this relationship shape.
`NSet to allow free-form editing (manual edits are not maintained in the model.)
User.DBNotation `7This formula conditionally sets the DBNotation setting.
`3Calculates a reference point for Relationship text.
User.CrowsFoot `<This formula conditionally sets the CrowsFoot notation flag.
Shape's version.
`"reference to associated text shape
?FkkÁ Õ?Fkk Q(-DT Q(-DT
Q(-DT Q(-DT
`'Locate referencial integrity text here.
Locate cardinality text here.
Database Properties... `0Edit the model properties for this relationship. DB Engineer /CMD=1001
Relational Notation `4Display this relationship using Relational notation. User.CrowsFoot User.Override user.dbnotation
IDEF1X Notation `0Display this relationship using IDEF1X notation. User.CrowsFoot User.Override user.dbnotation
Crow's Foot Notation `5Display this relationship using Crow's Foot symbols. User.CrowsFoot User.Override
`?Copyright (c) 2001 Microsoft Corporation. All rights reserved.
Lock Text Edit Toggel Lock Text Edit LockTextEdit Guard(0) LockTextEdit Guard(1)
Lock Delete Toggel Lock Delete LockDelete Guard(0) LockDelete Guard(1)
Relationships Relationships
Tracking text is used to annotate the Relationship shape.
10 = Tracking Text
DB Engineer /CMD=1003 PinX PinY User.OldPinX User.OldPinY
PinX guard(pntx(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
PinY guard(pnty(par(pnt(Sheet. !Controls.X Sheet. !Controls.Y
Shape ID to Track `BEnter the sheet id of the shape that you want this text to follow.
Control Row to Track `wIdentify the 'Tracked' shpe's control point by entering it's row number within the controls section of the shape sheet.
C:\Source\Developer\DBModeling\Visio Files\IE\Entity Relationship.vss
C:\Source\Developer\DBModeling\Visio Files\IE\Object Relational.vss
0 = IDEF1X, 2 = Relational
`$Set to hide category discriminators.
`:Set to hide PK, FK, and Index annotations within Entities.
`0Set to Hide Primary Key section within Entities.
`.Set to hide Datatypes section within Entities.
`bSet to hide the vertical lines that seperate the Annotation and Datatype sections within Entities.
`bSet to hide the horizontal line that seperates the PK section from the other columns of an Entity.
Type Inheritance
Composite Types
Table Inheritance Table Inheritance
Categories
Entities Entities
DB Engineer
/CMD=1 /MODEL=2
Guide
TheDoc
Page-1
Gesture Format
DBNotation
DBCrowsFoot
DBHideDiscriminator
DBHideAnnotations
DBHidePKRow
DBHideTypes
DBHideVerticalLines
DBHideHorizontalLine
ManualEdits
Connector
White line
Arial centered
Arial top left
Arial top
Times centered
Times top
Times top left
Dynamic Connector
Relationship
DBHideRelationships
DBHideRelationshipText
DBShapeType
RefShapeGuid
Identifying
DBCardinality
CrowsFoot
Optional
Override
OverrideDBNotation
EndAngle
OverrideCrowsFoot
BeginAngle
DBShapeVersion
RITextRefGuid
CardTextRefGuid
Watermark Title
Tracking Text
DBEventTrigger
OldPinX
OldPinY
Hide
SetPinX
SetPinY
RefSheetID
RefControl